package com.gxa.mapper;

import com.gxa.common.PageRecv;
import com.gxa.pojo.Dept;
import com.gxa.pojo.Document;
import com.gxa.pojo.Documentary;
import com.gxa.pojo.Employee;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * Created with IntelliJ IDEA.
 * User: 张剑宇
 * Date: 2021/12/02 18:49
 * Description:
 * Version: V1.0
 */
public interface DocumentaryMapper {



    //查询
    List<Documentary> findDocumentaryListMapper(PageRecv<Documentary> pageRecv);
    Integer findDocumentaryListCountMapper(PageRecv<Documentary> pageRecv);
    //删除
    Integer deleteDocumentaryMapper(Integer documentary_id);
    //添加
    Integer addDocumentaryMapper(Documentary documentary);
    //修改
    Integer updateDocumentaryMapper(Documentary documentary);
    //高级搜索
    List<Documentary> searchDocumentaryListMapper(PageRecv<Documentary> pageRecv);
    Integer searchDocumentaryListCountMapper(PageRecv<Documentary> pageRecv);
    //搜索
    List<Documentary> searchDocumentaryListLowMapper(@Param("limit") Integer limit1, @Param("pageSize") Integer pageSize, @Param("condition")String condition,@Param("employee_name")String employee);


    Integer searchDocumentaryListLowCountMapper(@Param("condition")String condition, @Param("employee_name")String employee_name);

    //查询所有员工
    List<Employee> queryEmployee();
    //查询所有员工的跟单数量
    Integer countDocumentaryByEmployee(@Param("employee_name")String employee_name,@Param("start_time")String start_time,@Param("stop_time")String stop_time);

    Integer countDocumentaryByDept(@Param("dept_name")String dept_name,@Param("start_time")String start_time,@Param("stop_time")String stop_time);
    //查询所有的的部门
    List<Dept> queryDept();

    List<Integer>findDocumentaryIdByCustomerId(Integer customer_id);
}
